﻿CREATE TABLE [dbo].[Meniuri_Zile] (
    [Data]    DATETIME NOT NULL,
    [IDMeniu] INT      NOT NULL,
    [IDRegim] INT      NOT NULL,
    CONSTRAINT [PK_Meniuri_Zile] PRIMARY KEY CLUSTERED ([Data] ASC, [IDMeniu] ASC, [IDRegim] ASC),
    CONSTRAINT [FK_Meniuri_Zile_MeniuriAlimentare] FOREIGN KEY ([IDMeniu]) REFERENCES [dbo].[MeniuriAlimentare] ([IDMeniu]),
    CONSTRAINT [FK_Meniuri_Zile_RegimuriAlimentare] FOREIGN KEY ([IDRegim]) REFERENCES [dbo].[RegimuriAlimentare] ([IDRegim])
);

